Market Analysis

This UiPath bot extracts stock tickers and a date from a given Excel spreadsheet and inputs them into a REST API call. The REST call pulls stock prices over the past 3 days of the extracted date in the spreadsheet. The bot also checks if any of the 3 days are on a weekend and automatically adjusts the dates for the call to the previous weekday, since the Stock Market is not open on weekends. The bot will then take that data and fill out the Date, Open and Close cells with their corresponding data from the REST call. You can download a copy of the automation and Excel file here and try it out for yourself!